EMT Practice Test

1. Question Content...

---

Question1: According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA?

Question2: Which of the following can be part of an analytic view? (3 answers)

Question3: What are the ABAP development guidelines? There are 2 correct answers to this question.

Question4: What allows you to resolve errors quickly or warnings reported about the code? Please choose the correct answer.

Question5: Which of the following are classes of the ABAP Database Connectivity (ADBC) API? 2 ans

Question6: You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? There are 3 correct answers to this question.

Question7: What is the full form of HANA?

Question8: What is the main purpose of Analytic Privilege?

Question9: Which of the following is not an element of Analytical view? Please choose the correct answer.

Question10: What is the main function of Static Code Analysis? Please choose the correct answer.

Question11: How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement?
Please choose the correct answer.

Question12: You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question.

Question13: What should you do to follow the code-to-data approach to programming? 2 ans

Question14: You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory? Note: There are 3 correct answers to this question.

Question15: In addition to closing the result set. what does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Please choose the correct answer.

Question16: What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view?

Question17: What language one should know to work in SAP HAN A?

Question18: What are the benefits of using the SQL Monitor (transaction SQLM)? There are 2 correct answers to this question.

Question19: What are the features of New Open SQL? There are 2 correct answers to this question.

Question20: You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias?
There are 3 correct answers to this question.

Question21: User STUDENT_A creates and activates a design-time Object. In which schema is the runtime object generated?

Question22: Which feature can you use to improve the performance of data transformation in the Extract, Transform and Load (ETL) process?

Question23: What is an attribute view and what are its practices? There are 3 correct answers to this question.

Question24: Which code-to-data capability is responsible for the Optimizations & Translation of "Open SQL SELECT FOR ALL ENTRIES clauses into native SQL?. Please choose the correct answer.

Question25: Which recent software innovations are applied in SAP HANA? 3 ans

Question26: You define and implement an AM DP. What do you have to list after the USING clause? There are 3 correct answers to this question.

Question27: Which system schema/user is the owner of all the activated objects?

Question28: What is the system privilege required to drop analytic privilege?

Question29: You implement an ABAP-managed database procedure (AMDP). You want to query data from Calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb.
How can you address the calculation view?
Note; There are 2 correct answers to this questions.

Question30: In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer

Question31: What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? (2 right answers)

Question32: When are referential joins executed in analytical views? Choose the correct answer

Question33: Which JOIN types can be used in the definition of a Core Data Services (CDS) view? 2 ans

Question34: DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types? There are 2 correct answers to this question.

Question35: You want to develop an ABAP application for SAP HANA using the front-end image of your Amazon Web Service (AWS) trial system. Which plug-ins do you need to add to the existing Eclipse installation?

Question36: Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 ans

Question37: Which system schema contains the list of Activated and inactive Objects?

Question38: Which of the following is latest release of SAP HANA?

Question39: What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.

Question40: Which system schema contains the list of Activated and inactive Objects?

Question41: Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? There are 2 correct answers to this question.

Question42: Which of the statements are true for SQLScript? (2 answers)

Question43: You apply static code checks on your ABAP coding to find performance optimization potential and receive a message about a "Problematic SELECT * statement" issue. How can you improve the performance of your ABAP code?

Question44: Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers to this question.

Question45: You apply static code checks on your ABAP coding to find potential functional regressions and receive a message about an "Unsecure use of FOR ALL ENTRIES'' issue. Which tool can you use to get additional runtime information?

Question46: You have created a CDS view as follows: define view zha400 as select from spfli association (*) to sflight as_flights On spfli.carrid =_flights.carrid and spfli.connid=_flights.connid
{
...
}
Given that table sflight also contains the field planetype, how must you address the fields carrid and planetype from table SFLIGHT?

Question47: How can you check if Core Data Services (CDS) views with scalar input parameters can be used in Open SQL queries in your system?

Question48: What are the key points that should be kept in mind while performing the Non-automatic update in SAP HANATr.Cont.? There are 2 correct answers to this question.

Question49: What are the two types of editors available in ADT? There are 2 correct answers to this question.

Question50: SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANAhas to meet. What are these goals?
There are 2 correct answers to this question.

Question51: What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 right answers)

Question52: When would you use a column store table instead of a row store table? There are 2 correct answers to this question.

Question53: You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? Please choose the correct answer.

Question54: Explain the Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question

Question55: Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question.

Question56: Which engine is used to execute Analytic View?

Question57: ANSI SQL owns features and adds languages. These languages divided into three parts. What are they? There are 3 correct answers to this question.

Question58: List down the three main concepts of the SAP HANA database There are 3 correct answers to this question

Question59: Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functional regressions?